Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 865 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 74.5 KiB |
| Average record size in memory | 88.1 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 10 |
Open is highly correlated with High and 4 other fields | High correlation |
High is highly correlated with Open and 4 other fields | High correlation |
Low is highly correlated with Open and 4 other fields | High correlation |
Close is highly correlated with Open and 4 other fields | High correlation |
Adj Close is highly correlated with Open and 4 other fields | High correlation |
S_10 is highly correlated with Open and 4 other fields | High correlation |
Open-Close is highly correlated with Volume and 1 other fields | High correlation |
Open-Open is highly correlated with Volume and 1 other fields | High correlation |
Volume is highly correlated with Open-Close and 1 other fields | High correlation |
Date has unique values | Unique |
Corr has unique values | Unique |
Open-Close has 19 (2.2%) zeros | Zeros |
Reproduction
| Analysis started | 2022-11-10 10:23:58.534832 |
|---|---|
| Analysis finished | 2022-11-10 10:24:08.272227 |
| Duration | 9.74 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 865 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 KiB |
| Minimum | 2019-06-06 00:00:00 |
|---|---|
| Maximum | 2022-11-08 00:00:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 745 |
|---|---|
| Distinct (%) | 86.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.82716765 |
| Minimum | 15.96000004 |
|---|---|
| Maximum | 63.25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | 15.96000004 |
|---|---|
| 5-th percentile | 23.34199982 |
| Q1 | 30.51000023 |
| median | 35.47000122 |
| Q3 | 44.99000168 |
| 95-th percentile | 56.31199951 |
| Maximum | 63.25 |
| Range | 47.28999996 |
| Interquartile range (IQR) | 14.48000145 |
Descriptive statistics
| Standard deviation | 9.908622816 |
|---|---|
| Coefficient of variation (CV) | 0.2619446137 |
| Kurtosis | -0.6420970844 |
| Mean | 37.82716765 |
| Median Absolute Deviation (MAD) | 6.909999847 |
| Skewness | 0.4539407918 |
| Sum | 32720.50001 |
| Variance | 98.18080611 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 33 | 5 | 0.6% |
| 45 | 4 | 0.5% |
| 31 | 4 | 0.5% |
| 37 | 3 | 0.3% |
| 30.39999962 | 3 | 0.3% |
| 29.11000061 | 3 | 0.3% |
| 41 | 3 | 0.3% |
| 36.5 | 3 | 0.3% |
| 32.09999847 | 3 | 0.3% |
| 32.33000183 | 3 | 0.3% |
| Other values (735) | 831 |
| Value | Count | Frequency (%) |
| 15.96000004 | 1 | |
| 17.76000023 | 1 | |
| 20.14999962 | 1 | |
| 20.18000031 | 1 | |
| 20.37000084 | 1 | |
| 20.70000076 | 1 | |
| 20.93000031 | 1 | |
| 21 | 1 | |
| 21.04000092 | 1 | |
| 21.06999969 | 1 |
| Value | Count | Frequency (%) |
| 63.25 | 1 | 0.1% |
| 62 | 1 | 0.1% |
| 61.02000046 | 1 | 0.1% |
| 60.74000168 | 1 | 0.1% |
| 60.34999847 | 1 | 0.1% |
| 60.33000183 | 1 | 0.1% |
| 60.11999893 | 1 | 0.1% |
| 60.11000061 | 1 | 0.1% |
| 60 | 3 | |
| 59.99000168 | 1 | 0.1% |
| Distinct | 782 |
|---|---|
| Distinct (%) | 90.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.59789251 |
| Minimum | 17.79999924 |
|---|---|
| Maximum | 64.05000305 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | 17.79999924 |
|---|---|
| 5-th percentile | 23.93199959 |
| Q1 | 31.25 |
| median | 36.31000137 |
| Q3 | 45.63999939 |
| 95-th percentile | 57.60200043 |
| Maximum | 64.05000305 |
| Range | 46.25000381 |
| Interquartile range (IQR) | 14.38999939 |
Descriptive statistics
| Standard deviation | 9.975656343 |
|---|---|
| Coefficient of variation (CV) | 0.2584508038 |
| Kurtosis | -0.6472829676 |
| Mean | 38.59789251 |
| Median Absolute Deviation (MAD) | 6.98000145 |
| Skewness | 0.4670898675 |
| Sum | 33387.17702 |
| Variance | 99.51371948 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 44.34999847 | 4 | 0.5% |
| 44.79999924 | 4 | 0.5% |
| 34 | 3 | 0.3% |
| 44.24000168 | 3 | 0.3% |
| 30.14999962 | 3 | 0.3% |
| 49.95000076 | 3 | 0.3% |
| 46.65999985 | 3 | 0.3% |
| 47.68999863 | 3 | 0.3% |
| 47.93999863 | 3 | 0.3% |
| 35.09999847 | 3 | 0.3% |
| Other values (772) | 833 |
| Value | Count | Frequency (%) |
| 17.79999924 | 1 | |
| 20.30999947 | 1 | |
| 21.12599945 | 1 | |
| 21.26000023 | 1 | |
| 21.37000084 | 1 | |
| 21.39999962 | 1 | |
| 21.46500015 | 1 | |
| 21.48999977 | 1 | |
| 21.61000061 | 1 | |
| 21.78000069 | 2 |
| Value | Count | Frequency (%) |
| 64.05000305 | 1 | |
| 63.5 | 1 | |
| 61.5 | 1 | |
| 61.31000137 | 1 | |
| 61.09000015 | 1 | |
| 61.06000137 | 1 | |
| 61.02000046 | 1 | |
| 61.00999832 | 1 | |
| 60.95000076 | 1 | |
| 60.93000031 | 1 |
| Distinct | 775 |
|---|---|
| Distinct (%) | 89.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.96529825 |
| Minimum | 13.71000004 |
|---|---|
| Maximum | 60.79999924 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | 13.71000004 |
|---|---|
| 5-th percentile | 22.45800056 |
| Q1 | 29.82999992 |
| median | 34.51499939 |
| Q3 | 43.95000076 |
| 95-th percentile | 54.97799988 |
| Maximum | 60.79999924 |
| Range | 47.0899992 |
| Interquartile range (IQR) | 14.12000084 |
Descriptive statistics
| Standard deviation | 9.767729332 |
|---|---|
| Coefficient of variation (CV) | 0.2642405119 |
| Kurtosis | -0.6574173423 |
| Mean | 36.96529825 |
| Median Absolute Deviation (MAD) | 6.664999008 |
| Skewness | 0.4273275148 |
| Sum | 31974.98299 |
| Variance | 95.4085363 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 55 | 3 | 0.3% |
| 35.25999832 | 3 | 0.3% |
| 33.54999924 | 3 | 0.3% |
| 32.5 | 3 | 0.3% |
| 48.52999878 | 3 | 0.3% |
| 29.36000061 | 3 | 0.3% |
| 43.56000137 | 3 | 0.3% |
| 31.40999985 | 3 | 0.3% |
| 31 | 3 | 0.3% |
| 30.47999954 | 2 | 0.2% |
| Other values (765) | 836 |
| Value | Count | Frequency (%) |
| 13.71000004 | 1 | |
| 15.69999981 | 1 | |
| 18.01000023 | 1 | |
| 19.10000038 | 1 | |
| 19.72999954 | 1 | |
| 19.89500046 | 1 | |
| 20.15500069 | 1 | |
| 20.37000084 | 1 | |
| 20.43000031 | 1 | |
| 20.5909996 | 1 |
| Value | Count | Frequency (%) |
| 60.79999924 | 1 | |
| 60.39500046 | 1 | |
| 59.84000015 | 1 | |
| 59.54999924 | 1 | |
| 59.54000092 | 1 | |
| 59.31499863 | 1 | |
| 59.18000031 | 1 | |
| 59.11999893 | 1 | |
| 58.95000076 | 1 | |
| 58.75 | 1 |
| Distinct | 756 |
|---|---|
| Distinct (%) | 87.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.77294798 |
| Minimum | 14.81999969 |
|---|---|
| Maximum | 63.18000031 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | 14.81999969 |
|---|---|
| 5-th percentile | 23.20800056 |
| Q1 | 30.45999908 |
| median | 35.22999954 |
| Q3 | 44.68999863 |
| 95-th percentile | 56.08800049 |
| Maximum | 63.18000031 |
| Range | 48.36000061 |
| Interquartile range (IQR) | 14.22999954 |
Descriptive statistics
| Standard deviation | 9.850326145 |
|---|---|
| Coefficient of variation (CV) | 0.2607772671 |
| Kurtosis | -0.6364361054 |
| Mean | 37.77294798 |
| Median Absolute Deviation (MAD) | 6.840000153 |
| Skewness | 0.4527817066 |
| Sum | 32673.6 |
| Variance | 97.02892517 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 31.68000031 | 3 | 0.3% |
| 32.68000031 | 3 | 0.3% |
| 34.25999832 | 3 | 0.3% |
| 33.40999985 | 3 | 0.3% |
| 45.72000122 | 3 | 0.3% |
| 39.70000076 | 3 | 0.3% |
| 33.04999924 | 3 | 0.3% |
| 21.5 | 3 | 0.3% |
| 31.37000084 | 3 | 0.3% |
| 27.81999969 | 3 | 0.3% |
| Other values (746) | 835 |
| Value | Count | Frequency (%) |
| 14.81999969 | 1 | |
| 18.90999985 | 1 | |
| 20.29000092 | 1 | |
| 20.45999908 | 1 | |
| 20.46999931 | 1 | |
| 20.48999977 | 1 | |
| 20.64999962 | 1 | |
| 21.09000015 | 1 | |
| 21.19000053 | 1 | |
| 21.32999992 | 1 |
| Value | Count | Frequency (%) |
| 63.18000031 | 1 | |
| 60.81000137 | 1 | |
| 60.74000168 | 1 | |
| 60.70999908 | 1 | |
| 60.63999939 | 1 | |
| 60.63000107 | 1 | |
| 60.52000046 | 1 | |
| 60.34999847 | 2 | |
| 60.18999863 | 1 | |
| 59.61000061 | 1 |
| Distinct | 756 |
|---|---|
| Distinct (%) | 87.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.77294798 |
| Minimum | 14.81999969 |
|---|---|
| Maximum | 63.18000031 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | 14.81999969 |
|---|---|
| 5-th percentile | 23.20800056 |
| Q1 | 30.45999908 |
| median | 35.22999954 |
| Q3 | 44.68999863 |
| 95-th percentile | 56.08800049 |
| Maximum | 63.18000031 |
| Range | 48.36000061 |
| Interquartile range (IQR) | 14.22999954 |
Descriptive statistics
| Standard deviation | 9.850326145 |
|---|---|
| Coefficient of variation (CV) | 0.2607772671 |
| Kurtosis | -0.6364361054 |
| Mean | 37.77294798 |
| Median Absolute Deviation (MAD) | 6.840000153 |
| Skewness | 0.4527817066 |
| Sum | 32673.6 |
| Variance | 97.02892517 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 31.68000031 | 3 | 0.3% |
| 32.68000031 | 3 | 0.3% |
| 34.25999832 | 3 | 0.3% |
| 33.40999985 | 3 | 0.3% |
| 45.72000122 | 3 | 0.3% |
| 39.70000076 | 3 | 0.3% |
| 33.04999924 | 3 | 0.3% |
| 21.5 | 3 | 0.3% |
| 31.37000084 | 3 | 0.3% |
| 27.81999969 | 3 | 0.3% |
| Other values (746) | 835 |
| Value | Count | Frequency (%) |
| 14.81999969 | 1 | |
| 18.90999985 | 1 | |
| 20.29000092 | 1 | |
| 20.45999908 | 1 | |
| 20.46999931 | 1 | |
| 20.48999977 | 1 | |
| 20.64999962 | 1 | |
| 21.09000015 | 1 | |
| 21.19000053 | 1 | |
| 21.32999992 | 1 |
| Value | Count | Frequency (%) |
| 63.18000031 | 1 | |
| 60.81000137 | 1 | |
| 60.74000168 | 1 | |
| 60.70999908 | 1 | |
| 60.63999939 | 1 | |
| 60.63000107 | 1 | |
| 60.52000046 | 1 | |
| 60.34999847 | 2 | |
| 60.18999863 | 1 | |
| 59.61000061 | 1 |
| Distinct | 864 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25573638.73 |
| Minimum | 3380000 |
|---|---|
| Maximum | 130965700 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | 3380000 |
|---|---|
| 5-th percentile | 7771600 |
| Q1 | 15787900 |
| median | 21976800 |
| Q3 | 30935900 |
| 95-th percentile | 54002480 |
| Maximum | 130965700 |
| Range | 127585700 |
| Interquartile range (IQR) | 15148000 |
Descriptive statistics
| Standard deviation | 15895280.1 |
|---|---|
| Coefficient of variation (CV) | 0.6215494115 |
| Kurtosis | 8.297154503 |
| Mean | 25573638.73 |
| Median Absolute Deviation (MAD) | 7439500 |
| Skewness | 2.245623901 |
| Sum | 2.21211975 × 1010 |
| Variance | 2.526599295 × 1014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 15570900 | 2 | 0.2% |
| 16403700 | 1 | 0.1% |
| 26232800 | 1 | 0.1% |
| 14260300 | 1 | 0.1% |
| 14230600 | 1 | 0.1% |
| 28868800 | 1 | 0.1% |
| 36717300 | 1 | 0.1% |
| 30368800 | 1 | 0.1% |
| 25374000 | 1 | 0.1% |
| 32165000 | 1 | 0.1% |
| Other values (854) | 854 |
| Value | Count | Frequency (%) |
| 3380000 | 1 | |
| 3775700 | 1 | |
| 3815300 | 1 | |
| 4021000 | 1 | |
| 4078700 | 1 | |
| 4412000 | 1 | |
| 4974000 | 1 | |
| 4986600 | 1 | |
| 5110100 | 1 | |
| 5251600 | 1 |
| Value | Count | Frequency (%) |
| 130965700 | 1 | |
| 115601800 | 1 | |
| 113915000 | 1 | |
| 112325800 | 1 | |
| 107926300 | 1 | |
| 106631700 | 1 | |
| 101818200 | 1 | |
| 95455100 | 1 | |
| 92468800 | 1 | |
| 89586000 | 1 |
| Distinct | 862 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.84440925 |
| Minimum | 21.58099995 |
|---|---|
| Maximum | 60.0720005 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | 21.58099995 |
|---|---|
| 5-th percentile | 23.37700001 |
| Q1 | 30.73900032 |
| median | 35.66499977 |
| Q3 | 44.55400009 |
| 95-th percentile | 55.9496003 |
| Maximum | 60.0720005 |
| Range | 38.49100056 |
| Interquartile range (IQR) | 13.81499977 |
Descriptive statistics
| Standard deviation | 9.683037721 |
|---|---|
| Coefficient of variation (CV) | 0.2558644173 |
| Kurtosis | -0.7226258281 |
| Mean | 37.84440925 |
| Median Absolute Deviation (MAD) | 6.769999886 |
| Skewness | 0.4504223274 |
| Sum | 32735.414 |
| Variance | 93.7612195 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 46.90800018 | 2 | 0.2% |
| 43.57099991 | 2 | 0.2% |
| 44.05500031 | 2 | 0.2% |
| 41.69999962 | 1 | 0.1% |
| 41.12199974 | 1 | 0.1% |
| 40.37499962 | 1 | 0.1% |
| 40.30199966 | 1 | 0.1% |
| 40.23999977 | 1 | 0.1% |
| 40.18199959 | 1 | 0.1% |
| 40.1159996 | 1 | 0.1% |
| Other values (852) | 852 |
| Value | Count | Frequency (%) |
| 21.58099995 | 1 | |
| 21.60300007 | 1 | |
| 21.60799999 | 1 | |
| 21.66299992 | 1 | |
| 21.70200005 | 1 | |
| 21.72099991 | 1 | |
| 21.78099995 | 1 | |
| 21.82600002 | 1 | |
| 21.84099998 | 1 | |
| 21.84900017 | 1 |
| Value | Count | Frequency (%) |
| 60.0720005 | 1 | |
| 60.01800041 | 1 | |
| 59.83000031 | 1 | |
| 59.74500046 | 1 | |
| 59.41600037 | 1 | |
| 59.39500008 | 1 | |
| 58.86999969 | 1 | |
| 58.84600029 | 1 | |
| 58.825 | 1 | |
| 58.61899986 | 1 |
| Distinct | 865 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3492483339 |
| Minimum | -0.8971070279 |
|---|---|
| Maximum | 0.9894741578 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 223 |
| Negative (%) | 25.8% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | -0.8971070279 |
|---|---|
| 5-th percentile | -0.5321411155 |
| Q1 | -0.01384845299 |
| median | 0.4672296735 |
| Q3 | 0.7730052605 |
| 95-th percentile | 0.9246571484 |
| Maximum | 0.9894741578 |
| Range | 1.886581186 |
| Interquartile range (IQR) | 0.7868537135 |
Descriptive statistics
| Standard deviation | 0.4806273313 |
|---|---|
| Coefficient of variation (CV) | 1.376176447 |
| Kurtosis | -0.8199726671 |
| Mean | 0.3492483339 |
| Median Absolute Deviation (MAD) | 0.349977253 |
| Skewness | -0.5878968539 |
| Sum | 302.0998089 |
| Variance | 0.2310026316 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.5038910512 | 1 | 0.1% |
| 0.8136090979 | 1 | 0.1% |
| 0.2631422682 | 1 | 0.1% |
| 0.3130738241 | 1 | 0.1% |
| 0.2520004858 | 1 | 0.1% |
| 0.6346820442 | 1 | 0.1% |
| 0.8011734177 | 1 | 0.1% |
| 0.7715586406 | 1 | 0.1% |
| 0.61425927 | 1 | 0.1% |
| 0.4834446681 | 1 | 0.1% |
| Other values (855) | 855 |
| Value | Count | Frequency (%) |
| -0.8971070279 | 1 | |
| -0.880482173 | 1 | |
| -0.8479065758 | 1 | |
| -0.7963937794 | 1 | |
| -0.7749648925 | 1 | |
| -0.7587808369 | 1 | |
| -0.7537084148 | 1 | |
| -0.7444070632 | 1 | |
| -0.7114156358 | 1 | |
| -0.7076789493 | 1 |
| Value | Count | Frequency (%) |
| 0.9894741578 | 1 | |
| 0.9865588555 | 1 | |
| 0.9847270844 | 1 | |
| 0.9839917919 | 1 | |
| 0.9809413079 | 1 | |
| 0.9792616219 | 1 | |
| 0.9771316593 | 1 | |
| 0.975417392 | 1 | |
| 0.9721817424 | 1 | |
| 0.9671383339 | 1 |
| Distinct | 411 |
|---|---|
| Distinct (%) | 47.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03391908965 |
| Minimum | -3.409999847 |
|---|---|
| Maximum | 4.88999939 |
| Zeros | 19 |
| Zeros (%) | 2.2% |
| Negative | 397 |
| Negative (%) | 45.9% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | -3.409999847 |
|---|---|
| 5-th percentile | -1.101998901 |
| Q1 | -0.25 |
| median | 0.02000045776 |
| Q3 | 0.3150005341 |
| 95-th percentile | 1.178000641 |
| Maximum | 4.88999939 |
| Range | 8.299999237 |
| Interquartile range (IQR) | 0.5650005341 |
Descriptive statistics
| Standard deviation | 0.757412958 |
|---|---|
| Coefficient of variation (CV) | 22.32999074 |
| Kurtosis | 5.996444882 |
| Mean | 0.03391908965 |
| Median Absolute Deviation (MAD) | 0.2900009155 |
| Skewness | 0.3484064571 |
| Sum | 29.34001255 |
| Variance | 0.573674389 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 19 | 2.2% |
| 0.02000045776 | 14 | 1.6% |
| -0.0299987793 | 11 | 1.3% |
| 0.1800003052 | 11 | 1.3% |
| 0.06999969482 | 10 | 1.2% |
| -0.1100006104 | 10 | 1.2% |
| -0.02000045776 | 9 | 1.0% |
| -0.06999969482 | 9 | 1.0% |
| 0.1399993896 | 8 | 0.9% |
| -0.09000015259 | 8 | 0.9% |
| Other values (401) | 756 |
| Value | Count | Frequency (%) |
| -3.409999847 | 1 | |
| -3.180000305 | 1 | |
| -2.979999542 | 1 | |
| -2.790000916 | 1 | |
| -2.510002136 | 1 | |
| -2.470001221 | 1 | |
| -2.450000763 | 1 | |
| -2.420001984 | 1 | |
| -2.420000076 | 1 | |
| -2.300001144 | 1 |
| Value | Count | Frequency (%) |
| 4.88999939 | 1 | |
| 3.88999939 | 1 | |
| 3.5 | 1 | |
| 3.13999939 | 1 | |
| 2.88999939 | 1 | |
| 2.799999237 | 1 | |
| 2.549999237 | 1 | |
| 2.440002441 | 1 | |
| 2.419998169 | 1 | |
| 2.38999939 | 1 |
| Distinct | 566 |
|---|---|
| Distinct (%) | 65.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.01768786039 |
| Minimum | -5.479999542 |
|---|---|
| Maximum | 6.570000648 |
| Zeros | 5 |
| Zeros (%) | 0.6% |
| Negative | 448 |
| Negative (%) | 51.8% |
| Memory size | 6.9 KiB |
Quantile statistics
| Minimum | -5.479999542 |
|---|---|
| 5-th percentile | -2.198000336 |
| Q1 | -0.7350006104 |
| median | -0.03999900818 |
| Q3 | 0.7200012207 |
| 95-th percentile | 2.077998352 |
| Maximum | 6.570000648 |
| Range | 12.05000019 |
| Interquartile range (IQR) | 1.455001831 |
Descriptive statistics
| Standard deviation | 1.330979613 |
|---|---|
| Coefficient of variation (CV) | -75.24819758 |
| Kurtosis | 2.383784262 |
| Mean | -0.01768786039 |
| Median Absolute Deviation (MAD) | 0.7199993134 |
| Skewness | 0.1628849725 |
| Sum | -15.29999924 |
| Variance | 1.771506731 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -0.5 | 7 | 0.8% |
| -0.5900001526 | 7 | 0.8% |
| -0.1599998474 | 7 | 0.8% |
| 0.3899993896 | 6 | 0.7% |
| -0.75 | 6 | 0.7% |
| -0.7000007629 | 6 | 0.7% |
| -0.04999923706 | 5 | 0.6% |
| -0.3899993896 | 5 | 0.6% |
| 0 | 5 | 0.6% |
| 0.1399993896 | 5 | 0.6% |
| Other values (556) | 806 |
| Value | Count | Frequency (%) |
| -5.479999542 | 1 | |
| -4.700000763 | 1 | |
| -4.649999619 | 1 | |
| -4.649997711 | 1 | |
| -4.259998322 | 1 | |
| -4.059997559 | 1 | |
| -3.920000076 | 1 | |
| -3.86000061 | 1 | |
| -3.63999939 | 1 | |
| -3.5 | 1 |
| Value | Count | Frequency (%) |
| 6.570000648 | 1 | |
| 5.919998169 | 1 | |
| 5.38999939 | 1 | |
| 5.059999466 | 1 | |
| 4.870000839 | 1 | |
| 4.040000916 | 1 | |
| 3.820001602 | 1 | |
| 3.459999084 | 1 | |
| 3.450000763 | 1 | |
| 3.340000153 | 1 |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Date | Open | High | Low | Close | Adj Close | Volume | S_10 | Corr | Open-Close | Open-Open | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019-06-06 | 45.000000 | 45.750000 | 44.279999 | 44.919998 | 44.919998 | 16403700 | 41.700000 | 0.503891 | 0.000000 | 2.130001 |
| 1 | 2019-06-07 | 44.919998 | 45.669998 | 44.130001 | 44.160000 | 44.160000 | 12654700 | 42.068999 | 0.567517 | 0.000000 | -0.080002 |
| 2 | 2019-06-10 | 44.020000 | 44.590000 | 42.529999 | 42.610001 | 42.610001 | 11618700 | 42.179000 | 0.495415 | -0.139999 | -0.899998 |
| 3 | 2019-06-11 | 43.220001 | 43.650002 | 41.799999 | 42.450001 | 42.450001 | 9095000 | 42.329000 | 0.431182 | 0.610001 | -0.799999 |
| 4 | 2019-06-12 | 42.520000 | 42.650002 | 41.709999 | 42.169998 | 42.169998 | 5965300 | 42.552000 | 0.328851 | 0.070000 | -0.700001 |
| 5 | 2019-06-13 | 43.049999 | 44.349998 | 42.799999 | 44.310001 | 44.310001 | 10178900 | 43.003000 | 0.361911 | 0.880001 | 0.529999 |
| 6 | 2019-06-14 | 44.750000 | 44.799999 | 43.110001 | 43.230000 | 43.230000 | 7902200 | 43.285000 | 0.132678 | 0.439999 | 1.700001 |
| 7 | 2019-06-17 | 43.279999 | 44.078999 | 42.930000 | 43.779999 | 43.779999 | 6557600 | 43.538000 | -0.138791 | 0.049999 | -1.470001 |
| 8 | 2019-06-18 | 44.299999 | 44.889999 | 43.750000 | 43.860001 | 43.860001 | 7313600 | 43.649000 | -0.277532 | 0.520000 | 1.020000 |
| 9 | 2019-06-19 | 44.459999 | 45.500000 | 43.950001 | 44.860001 | 44.860001 | 10331500 | 43.635000 | 0.160496 | 0.599998 | 0.160000 |
Last rows
| Date | Open | High | Low | Close | Adj Close | Volume | S_10 | Corr | Open-Close | Open-Open | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 855 | 2022-10-26 | 28.170000 | 28.980000 | 27.865000 | 28.200001 | 28.200001 | 17315900 | 27.089 | -0.636264 | -0.190001 | 0.170000 |
| 856 | 2022-10-27 | 28.400000 | 28.760000 | 27.660000 | 27.820000 | 27.820000 | 16768600 | 27.371 | -0.293399 | 0.199999 | 0.230000 |
| 857 | 2022-10-28 | 27.809999 | 27.879999 | 26.490000 | 27.500000 | 27.500000 | 27116700 | 27.650 | -0.142812 | -0.010000 | -0.590000 |
| 858 | 2022-10-31 | 27.610001 | 27.730000 | 26.299999 | 26.570000 | 26.570000 | 37327000 | 27.713 | -0.520966 | 0.110001 | -0.199999 |
| 859 | 2022-11-01 | 30.070000 | 31.000000 | 29.120001 | 29.750000 | 29.750000 | 87994000 | 27.927 | 0.153811 | 3.500000 | 2.459999 |
| 860 | 2022-11-02 | 29.570000 | 30.160000 | 28.629999 | 28.809999 | 28.809999 | 37083500 | 28.055 | 0.248417 | -0.180000 | -0.500000 |
| 861 | 2022-11-03 | 28.030001 | 29.520000 | 27.709999 | 28.730000 | 28.730000 | 28033200 | 28.141 | 0.312576 | -0.779999 | -1.539999 |
| 862 | 2022-11-04 | 29.440001 | 29.725000 | 28.040001 | 28.389999 | 28.389999 | 22292400 | 28.178 | 0.340572 | 0.710001 | 1.410000 |
| 863 | 2022-11-07 | 28.705000 | 28.825001 | 27.615000 | 27.690001 | 27.690001 | 19204100 | 28.182 | 0.179257 | 0.315001 | -0.735001 |
| 864 | 2022-11-08 | 27.570000 | 28.330000 | 26.820000 | 27.440001 | 27.440001 | 27033900 | 28.090 | 0.213816 | -0.120001 | -1.135000 |